The Import Lookup Tables section is used to load standard lookup tables into the data processing database. Most of the lookup tables are used in Isometric processing. Currently, these tables are hard-coded.

A commonly-used lookup table is the RemoveComponentsFromCC table, which is used to delete unwanted components (based on property values) from data processing that cannot be removed via standard configuration. This is run in the End-To-End Data Run workflow in CAD Post-Processing.

By selecting the table from the Select a Table drop-down list, the table column names display.

Sample Microsoft Excel file laid out in the same fashion as the table

Selecting the Microsoft Excel file reads the data into the user interface. Select the appropriate settings for whether the file has headers, which row to start the import, and whether to overwrite or append the data. Click the View buttons to preview the import.

Map the applicable column names to the Microsoft Excel headers and then click Import. Repeat this process for any of the lookup tables, as required.